The Data tab contains a list of references to Data Definitions that are used within this Action. It allows you to provide run time settings for the Data Connections assigned to the Data Definitions. It also assists the Flow application to manage the connection and opening of the Data Definitions in the most efficient manner.
All the other Tabs of the Action that has reference to a Data Definition are referring to the list of Data Definitions on this Tab. You must add a reference to this Tab before you can use the Data Definition in the other Tabs. Any references to Data Connections will also only include the Data Connections assigned to the Data Definitions on this Tab.
When modifying an existing process it is a common mistake to reassign the Data Connections on the Data Definitions themselves but not update the assignments on this Data Tab. Any change to the Data Connections on the Data Definitions themselves will not change where the Action connects to retrieve its data.
Field Name | Description |
---|---|
Data List | A list of references to Data Definitions. Single click an entry to edit its settings. Double click an entry to remove it. You can drag the entries to re-order them. Slow double click and entry to rename it. |
The following fields are only displayed when you have selected an entry in the Data List. Not all fields are displayed for all data references depending on whether it is a DB, File, or Web Definition |
|
Definition | Select the Data Definition you want to reference |
DB Connections | Select the DB Connections used on this Data Definition. This is a run time setting and overrides the design time setting done on the Data Definition. |
Use a separate "SQL Transaction" for this database connection | (DB Definitions Only) Select whether this DB Definition will uses it own SQL Transaction against the database |
File Connection | (File Definitions Only) Select the File Connection used on this File Definition. This is a run time setting and overrides the design time setting done on the File Definition. |
Web Connection | (Web Definitions Only) Select the Web Connection used on this Web Definition. This is a run time setting and overrides the design time setting done on the Web Definition. |
Dynamic Search Parameters | (DB Definitions Only) A list of dynamic search parameters that have been configured on the DB Definition. This allows you to specify the value of these search parameters for this particular action |
Allow DB Connection to change to that specified on the trading partner | Select to allow the DB Connections to change to those configured on any trading partner assigned to this Action. Useful when working with a configuration where different trading partners have their own databases. |
Allow user to populate parameters when action is executed |
Select to have the Dynamic Search Parameters pop-up at run time so they user can provide values specific to that execution of the Action. This is only allowed if the Action has been configured to run manually |
Preview data before saving |
Select to have the results of a mapping displayed in a grid editor prior to be saved to the output. This allows you to manually modify the results prior to output. This is only allowed if the Action has been configured to run manually |